Step 1: Create Sub vs Graded
- Copy and Paste Avg Non Graded Days
- Change Indicator to Sub vs Graded and Target goals to Sub vs Graded goal
- Select Format under general X position = 592, Y position = 145, Width = 289, Height = 160
- Color coding = High is good
- Title = Sub vs Graded
- Format Sub vs Graded and Sub vs Graded goal to a percentage.
Step 2: Create KPI background
- Select Format from top pane, then choose selection, choose Average of Non Graded Days
- Copy and Paste Avg. Non graded days background
- Move to align with new KPI card
- Change values to Sub vs Graded
Step 3: Create Sub vs Non Graded
- Copy and Paste Sub vs Graded
- Change Indicator to Sub vs Non Graded and Target goals to Sub vs Non Graded goal
- Select Format under general X position = 592, Y position = 347, Width = 289, Height = 160
- Color coding = Low is good
- Title = Sub vs Graded
- Format Sub vs Non Graded and Sub vs Non Graded goal to a percentage.
Step 4: Create KPI background
- Select Format from top pane, then choose selection, choose Sub vs Ungraded by Rolling weeks
- Copy and Paste Sub vs Ungraded by Rolling weeks background
- Move to align with new KPI card
- Change values to Sub vs Ungraded by rolling weeks
Step 5: Create Avg Days to Grade
- Copy and Paste Sub vs Non Graded
- Change Indicator to Avg Days to Grade and Target goals to Avg Days to Grade Goal
- Select Format under general X position = 592, Y position = 550, Width = 289, Height = 160
- Color coding = Low is good
- Title =Avg Days to Grade
Step 6: Create KPI background
- Select Format from top pane, then choose selection, choose Sub vs Ungraded by Rolling weeks
- Copy and Paste Sub vs Ungraded by Rolling weeks background
- Move to align with new KPI card
- Change values to Avg Days to Grade
Creating KPI cards .